Equality of access to public playgrounds for children in the city of Berlin
Data
Lebensweltlich orientierte Räume (LORs) of Berlin - A system by the municipality to split Berlin into smaller areas. The finest granularity are 542 “Planungsräume” (PLRs). [daten.berlin.de]
Inhabitants of Berlin 06/2021 - Number of inhabitants per PLR, split up by age [statistik-berlin-brandenburg.de]
Children in poverty 12/2020 - Percentage of children living in poverty per PLR, taken out of the report on social city development [daten.berlin.de]
Playgrounds in Berlin as of March 2023 - A list of publicly owned playgrounds accessible to every citizen [daten.berlin.de]
Hypothesis
With this data, I can analyze if playground access is distributed fairly among the population of children living in the city.
I can check how many playgrounds and how much playarea is available to each child. I can further break down the analysis to each PLR and calculate the availability of playgrounds relative to the amount of children living said PLR. Finally, I can compare these values with regard to different levels of child poverty in each PLR.
Importance
Cooperation, exploration, play and physical exercise are important factors for a healthy development of children. Part of a municipality’s obligation is to ensure and foster the healthy development of its population and minor citizens. Public playgounds are an important part of these efforts. But public playgrounds are heterogenous in size and location as is the distribution of the population of children the playgrounds are meant for. Families of children living in poverty might not have the political leverage to ensure equal access and availability of playgrounds for their children. Analyzing and reporting on the fairness of distribution and accessability of these public efforts is the responsibility of the press. Informing the public on the outcome of public investments serves as a control mechanism of power.
Main findings
- Berlin features 1797 proper public playgrounds for its 611899 children
- Differences are considerable: playground area per child between PLRs range from 0m² to 38.1m²
- These differences do not follow a clear geographical pattern
- Half of the PLRs feature a playarea to child ratio between 1.90m² and 5.49m²
- Median play area of playgrounds is 875m²
- Child poverty is not a factor in the distribution: the pearson correlation coefficient between child poverty and playground area across PLRs is -0.074.
Visualizations

This Chloropleth allows for a comparison of the available playarea for each child in the respective PLRs. There is no clear geographic pattern.

This Figure shows that there is no clear correlation between the playarea available to each child per PLR and the child poverty percentage of that PLR.

Visualisation of the differences in playground area per child across all PLRs. The blue box represents the PLRs with values in between the first and third quartile (interquartile range). Within that box, 50 percent of values are located.

Equality of access to public playgrounds for children in the city of Berlin
Data
Lebensweltlich orientierte Räume (LORs) of Berlin - A system by the municipality to split Berlin into smaller areas. The finest granularity are 542 “Planungsräume” (PLRs). [daten.berlin.de]
Inhabitants of Berlin 06/2021 - Number of inhabitants per PLR, split up by age [statistik-berlin-brandenburg.de]
Children in poverty 12/2020 - Percentage of children living in poverty per PLR, taken out of the report on social city development [daten.berlin.de]
Playgrounds in Berlin as of March 2023 - A list of publicly owned playgrounds accessible to every citizen [daten.berlin.de]
Hypothesis
With this data, I can analyze if playground access is distributed fairly among the population of children living in the city.
I can check how many playgrounds and how much playarea is available to each child. I can further break down the analysis to each PLR and calculate the availability of playgrounds relative to the amount of children living said PLR. Finally, I can compare these values with regard to different levels of child poverty in each PLR.
Importance
Cooperation, exploration, play and physical exercise are important factors for a healthy development of children. Part of a municipality’s obligation is to ensure and foster the healthy development of its population and minor citizens. Public playgounds are an important part of these efforts. But public playgrounds are heterogenous in size and location as is the distribution of the population of children the playgrounds are meant for. Families of children living in poverty might not have the political leverage to ensure equal access and availability of playgrounds for their children. Analyzing and reporting on the fairness of distribution and accessability of these public efforts is the responsibility of the press. Informing the public on the outcome of public investments serves as a control mechanism of power.
Main findings
Visualizations
This Chloropleth allows for a comparison of the available playarea for each child in the respective PLRs. There is no clear geographic pattern.
This Figure shows that there is no clear correlation between the playarea available to each child per PLR and the child poverty percentage of that PLR.
Visualisation of the differences in playground area per child across all PLRs. The blue box represents the PLRs with values in between the first and third quartile (interquartile range). Within that box, 50 percent of values are located.
This map shows how much of the total area of each PLR is dedicated as playarea.
Outlook
To pour this analysis into an article, I would drastically reduce the complexity of visualisations and numbers provided. This is the output of a data analysis and nowhere near an article presentable to the average audience. The lack of data leaves questions open about the quality of playgrounds, the accessibilty of playgrounds via public transportation or other means of transportation. Instead of mulitple figures and plots, I would provide an interactive map, so the reader is able to familiarize themself with the findings.
This could be a start:
Limitations